package vip.xiaonuo.smzq.modular.kcl.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import vip.xiaonuo.smzq.modular.kcl.entity.Bazycl;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * 备案资源储量 Mapper
 *
 * @author eomer
 * @since 2024-02-22
 */
@Mapper
public interface BazyclMapper extends BaseMapper<Bazycl> {




    /**
     * 查询报告序号
     *
     * @param kqbm 区块编码
     * @param djflbm 登记分类编码
     * @param nd 年度
     * @return
     */
    @Select("select bgsxh from kcl_bazycl where kqbh=#{kqbm} and djflbh=#{djflbm} and nd=#{nd} GROUP BY bgsxh ORDER BY bgsxh")
    List<Integer> getBgsxhList(@Param("kqbm") String kqbm, @Param("djflbm")Integer djflbm, @Param("nd")Integer nd);
}
